import pandas as pd
df = pd.read_csv('vehicle_positions.txt')
stops = pd.read_csv('Bus_Stops.csv')
stops.dropna(subset= ['stop_lat', 'stop_lon', 'Routes'], inplace = True)
df.dropna(inplace=True)
df.start_date = df.start_date.astype(int)
df.loc[df['route_id'].isin(['34', '66', '40'])]
stops34 = stops[stops['Routes'].str.contains('34')]
fig = px.scatter_mapbox(
df.loc[df['route_id'].isin(['34'])],
lat="latitude",
lon="longitude",
color="vehicle.id",
hover_data=["direction_id", "vehicle.id"],
color_continuous_scale=px.colors.cyclical.IceFire,
size_max=15,
zoom=10,
animation_frame="start_date",
title='Bus #34',
)
fig.show()
fig = px.scatter_mapbox(
df.loc[df['route_id'].isin(['66'])],
lat="latitude",
lon="longitude",
color="vehicle.id",
hover_data=["direction_id", "vehicle.id"],
color_continuous_scale=px.colors.cyclical.IceFire,
size_max=15,
zoom=10,
animation_frame="start_date",
title='Bus #66',
)
fig.show()